Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_AW_CUBE_ENABLED_HIERCOMBO

`ALL_AW_CUBE_ENABLED_HIERCOMBO` lists the hierarchy combinations associated with cubes in analytic workspaces.

Each hierarchy combination is identified by a unique number. The OLAP API Enabler creates a separate fact view for each hierarchy combination.

The information in this view is available for all standard form cubes that have been refreshed. See the `DBMS_AWM.REFRESH_AWCUBE` procedure and the `DBMS_AWM.CREATE_AWCUBE_ACCESS` procedure.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`aw_owner` | `varchar2(30)` |  | Owner of the analytic workspace.
`aw_name` | `varchar2(30)` |  | Name of the analytic workspace.
`cube_name` | `varchar2(4000)` |  | Name of the cube in the analytic workspace.
`hiercombo_num` | `number` |  | Unique number that identifies the hierarchy combination.
`hiercombo_str` | `varchar2(4000)` |  | List of hierarchies that define the dimensionality of a fact view of the enabled cube.